package com.lswms.modules.lswms.dao.stock;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.poi.ss.formula.functions.T;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.lswms.common.dao.BaseDao;
import com.lswms.modules.lswms.entity.stock.LotEntity;

/**
 * 属性
 *
 * @author DX sunlightcs@gmail.com
 * @since 1.0.0 2021-06-14
 */
@Mapper
public interface LotDao extends BaseDao<LotEntity> {
	
	@Select(value ="select lswms_lot.* ,lswms_sku.descr, lswms_sku.factorycdoe factorycdoe from lswms_lot  left join lswms_sku  on lswms_lot.sku = lswms_sku.sku  ${ew.customSqlSegment}")
	IPage<LotEntity> selectPageBySql(IPage<LotEntity> page, @Param(Constants.WRAPPER) Wrapper<LotEntity> queryWrapper);
}